createSnowflakeDataSource
This mutation creates a new Data Source from the given Snowflake database using the specified Snowflake account, warehouse, schema, username, and role.
The mutation returns the newly created Data Source (or an error message if creating the Data Source fails).
A Data Source is a connection to your data warehouse. It has the necessary connection details for Propel to access Snowflake or any other supported Data Source.
Arguments
input required createSnowflakeDataSourceInput
The fields for creating a Snowflake Data Source.
input.uniqueName optional String
The Data Source's unique name. If not specified, Propel will set the ID as unique name.
input.description optional String
The Data Source's description.
input.connectionSettings required SnowflakeConnectionSettingsInput
The Data Source's connection settings.
The fields for creating a Snowflake Data Source's connection settings.
input.connectionSettings.account required String
The Snowflake account. Only include the part before the "snowflakecomputing.com" part of your Snowflake URL (make sure you are in classic console, not Snowsight). For AWS-based accounts, this looks like "znXXXXX.us-east-2.aws". For Google Cloud-based accounts, this looks like "ffXXXXX.us-central1.gcp".
input.connectionSettings.database required String
The Snowflake database name.
input.connectionSettings.warehouse required String
The Snowflake warehouse name. It should be "PROPELLING" if you used the default name in the setup script.
input.connectionSettings.schema required String
The Snowflake schema.
input.connectionSettings.username required String
The Snowflake username. It should be "PROPEL" if you used the default name in the setup script.
input.connectionSettings.password required String
The Snowflake password.
input.connectionSettings.role required String
The Snowflake role. It should be "PROPELLER" if you used the default name in the setup script.
Returns
Nullable DataSourceOrFailureResponse
The result of a mutation which creates or modifies a DataSource.
If successful, an DataSourceResponse
will be returned; otherwise, a
FailureResponse
will be returned.