Snowflake

EventNative supports Snowflake as a destination. For more information about Snowflake see docs.
Configuration
Snowflake destination in batch mode can be configured via S3 or Google Cloud Storage. In the stream mode, it can be configured without any. The config consists of the following schema:
destinations:
  my_snowflake_via_aws_s3_or_gcp:
    type: snowflake 
    snowflake:
      account: hha56552.us-east-1
      schema: MYSCHEMA
      warehouse: my_warehouse
      db: mydb
      username: user
      password: pass
      parameters:
        name: value
      stage: my_stage
# via s3        
    s3:
      access_key_id: ...
      secret_access_key: ...
      bucket: ...
      region: ...
# or via gcp
    google:
      gcs_bucket: ...
      key_file: ...
snowflake
Field (*required)
Type
Description
Default value
account*
string
Snowflake global account.
-
port
int
Port of destination.
443
db*
string
Database of destination.
-
schema
string
Schema of destination.
public
username*
string
Username for authorization in a destination.
-
password
string
Password for authorization in a destination.
-
warehouse*
string
Snowflake warehouse name.
​
parameters
object
Connection parameters.
client_session_keep_alive=true
stage**
string
Name of Snowflake stage. It is required in batch mode.
-
s3
S3
/configuration-1/destination-configuration/s3
google
BigQuery
/configuration-1/destination-configuration/bigquery

Google Analytics

Redshift

Last updated 2 months ago

Field (*required)	Type	Description	Default value
account*	string	Snowflake global account.	-
port	int	Port of destination.	`443`
db*	string	Database of destination.	-
schema	string	Schema of destination.	`public`
username*	string	Username for authorization in a destination.	-
password	string	Password for authorization in a destination.	-
warehouse*	string	Snowflake warehouse name.
parameters	object	Connection parameters.	`client_session_keep_alive=true`
stage**	string	Name of Snowflake stage. It is required in batch mode.	-