Examples for cloud database deployments
The examples in this section demonstrate how to use
create-db
to create a database schema for cloud database
deployments.
Note: The default database might be
different for an on-premises installation than it is for a cloud provider. For
example, the default database for Postgres is usually
postgres
.
Note: Some of the following PostgreSQL examples show
spotfire-database
as the name
assigned to the option
--spotfiredb-dbname
. For this option, the value to use
specifies the database name to create for Spotfire.
- The variable
database-name
specifies an existing database. For cloud providers, this variable is required only if you set the value ofadmin-username
to a value other than the default postgres. Otherwise, PostgreSQL can connect to the default PostgreSQL database and create the Spotfire schema. - For cloud providers. if
you create a Spotfire database schema and specify
admin-username
as a value other than postgres (for example, admin), and you try to connect to a PostgreSQL database with that name, then PostgreSQL connects you to an existing database.
- Example script: PostgreSQL database on AWS using create-db command
The following example shows planning for and creating a Spotfire database schema for a PostgreSQL database on AWS. - Example script: PostgreSQL database on Google Cloud using create-db command
The following example shows planning for and creating a Spotfire database schema for a PostgreSQL database on Google Cloud. - Example script: PostgreSQL database on Azure using create-db command
The following example shows planning for and creating a Spotfire database schema for a PostgreSQL database on Azure. - Example script: Microsoft SQL database on AWS using create-db command
The following example shows planning for and creating a Spotfire database schema for a Microsoft SQL database on AWS. - Example script: Microsoft SQL database on Google Cloud using create-db command
The following example shows planning for and creating a Spotfire database schema for a Microsoft SQL database on Google Cloud. - Example script: Microsoft SQL database on Azure using create-db command
The following example shows planning for and creating a Spotfire database schema for a Microsoft SQL database on Azure. - Example script: Oracle database on AWS using create-db command
The following example shows planning for and creating a Spotfire database schema for a Oracle database on AWS.
- Example script: PostgreSQL database on AWS using create-db command
The following example shows planning for and creating a Spotfire database schema for a PostgreSQL database on AWS. - Example script: PostgreSQL database on Google Cloud using create-db command
The following example shows planning for and creating a Spotfire database schema for a PostgreSQL database on Google Cloud. - Example script: PostgreSQL database on Azure using create-db command
The following example shows planning for and creating a Spotfire database schema for a PostgreSQL database on Azure. - Example script: Microsoft SQL database on AWS using create-db command
The following example shows planning for and creating a Spotfire database schema for a Microsoft SQL database on AWS. - Example script: Microsoft SQL database on Google Cloud using create-db command
The following example shows planning for and creating a Spotfire database schema for a Microsoft SQL database on Google Cloud. - Example script: Microsoft SQL database on Azure using create-db command
The following example shows planning for and creating a Spotfire database schema for a Microsoft SQL database on Azure. - Example script: Oracle database on AWS using create-db command
The following example shows planning for and creating a Spotfire database schema for a Oracle database on AWS.
Parent topic: Creating a Spotfire database using the command create-db
Related information