Connecting to the Snowflake source database
In the Source Settings section, provide the details for the connection to the source database.
Selecting whether to use a connection string
By default, you provide the connection information in the individual connection fields.
To instead use a connection string, toggle Use connection string to the on position.
Selecting the authentication method to use
By default, the connection uses key pair authentication, and the Use Key Pair Authentication toggle is in the on position.
To instead use a password, toggle Use Key Pair Authentication to the off position.
Providing the source connection information
Populating the source connection fields
If Use server credentials is selected:
In the Server field, provide the server where the database is located. You must provide the full path to the server.
https://is optional. So the format of the server value can be either:<account>.<region>.snowflakecomputing.comhttps://<account>.<region>.snowflakecomputing.com
For example:
abc123456.us-east-1.snowflakecomputing.comorhttps://abc123456.us-east-1.snowflakecomputing.comIn the Database field, provide the name of the database.
In the Username field, provide the username for the account to use to connect to the database. If secrets managers are available, you can select a secret name from a secrets manager.
Providing a source connection string
If Use connection string is selected, then in the Connection String field, provide the connection string.
The connection string uses the following format:
Providing source authentication details
Key pair authentication
If key pair authentication is enabled (Use Key Pair Authentication is in the on position):
For RSA Private Key, click Browse, then select the key file.
If the key is encrypted, then in the Encrypted Key Passphrase field, provide the passphrase to use to decrypt the key.
Password authentication
If key pair authentication is disabled (Use Key Pair Authentication is in the off position), then in the Password field, either:
Specify the password manually.
If secrets managers are available, select a secret name from a secrets manager.
Testing the source connection
To test the connection to the source database, click Test Source Connection.
Indicating whether to trust the server certificate
To trust the server certificate, and ignore the certificate authority's revocation list, toggle Trust Server Certificate to the on position.
This option can be useful when your Tonic Structural instance cannot connect to the certificate authority.
Using an alternative connection method
To make the connection, you can optionally use either:
A proxy connection
Tailscale tunneling
To enable an alternative connection method, toggle Enable Connection Method to the on position.
Using a proxy connection
To use a proxy server to connect to the source database:
From the Connection Method dropdown list, select Proxy.
In the Proxy Host field, provide the host name for the proxy connection.
In the Proxy Port field, provide the port for the proxy connection.
Optionally, in the Proxy User field, provide the name of the user for the proxy connection.
If you provide a proxy user, then in the Proxy Password field, provide the password for the specified user.
Optionally, in the Non-Proxy Hosts field, provide the list of hosts for which to bypass the proxy server and connect to directly.
Use a pipe symbol (|) to separate the host names. For example, host1|host2|host3.
You can also use an asterisk (*) as a wildcard. For example, to connect directly to all hosts with host names that start with myhost, use myhost*.
Using Tailscale tunneling
To use a Tailscale tunnel to connect to the source database:
From the Connection Method dropdown list, select Tailscale Tunnel.
In the Tags field, provide a comma-separated list of ACL tags to use to join the tailnet. For example,
tag:tonic-worker.Optionally, in the Control Server URL field, provide the URL. This is intended for customers who use Headscale or a self-hosted Tailscale control plane.
In the Tailscale Auth Key field, provide a Tailscale OAuth client credential. Structural does not support other types of Tailscale keys, such as user auth keys. You create the credential from the OAuth clients page in your Tailscale admin console. If secrets managers are available, you can instead select a secret name from a secrets manager.
Limiting the included schemas
By default, the source database includes all of the schemas. To specify a list of specific schemas to either include or exclude:
Toggle Limit Schemas to the on position.
From the filter option dropdown list, select whether to include or exclude the listed schemas.
In the field, provide the list of schemas to either include or exclude. Use commas or semicolons to separate the schemas.
Do not exclude schemas that are referred to by included schemas, unless you create those schemas manually outside of Structural.
Last updated
Was this helpful?