Snowflake is in beta. The tile on the Integrations page is marked Beta.
Prerequisites
- A Snowflake user with an administrator role, to run the setup script.
- Your Snowflake account URL.
Set up the Snowflake integration
1
Open the Snowflake form
Under Data, select Integrations. On the Snowflake tile, select Connect.
2
Enter the connection details
On Connection details, fill in the fields below, then select Continue.
3
Run the setup script in Snowflake
On Set up Snowflake, OPTIMAZE shows a Setup SQL script and a Public key it generated for you.
Copy the Setup SQL and run it in Snowflake as an administrator. It creates the read-only views and registers the public key for the user.
OPTIMAZE keeps the private key and never shows it.
4
Connect and test
Select Connect and test.
What happens next
When you select Connect, OPTIMAZE runs a connection check before it starts importing. Each part of the check shows as passed, failed or not checked, and a later part is not checked when an earlier one fails.
Once the check passes, the integration appears under Connected on the Integrations page. OPTIMAZE imports the previous six months of history on the first sync, and each later sync re-reads the last three days to pick up late changes.
If OPTIMAZE cannot read your credit price, compute costs arrive without a dollar value and the integration shows Credit price missing. Grant the role access to the organisation usage views, or reconnect with a Credit price.
Troubleshooting
- Authentication fails: the setup script was not run, or was run for a different user. Run it again as an administrator.
- Required objects fails: the views the script creates are missing. Check the Database and Schema match the script, then run it again.
- Credit price missing: grant the role access to the organisation usage views, or reconnect with a Credit price.
- Data available fails: Snowflake has no cost data for the period yet. Wait for Snowflake to report usage, then connect again.