Foundational

To get started, read <a href="https://docs.foundational.io/en/articles/9711709">On-Premise Agent Setup</a>

Follow the instructions in <a href="https://docs.foundational.io/en/articles/8292929">How to set up Snowflake</a> to get Snowflake's connection parameters<i>.</i>

The details you've collected need to fit into:

1. <code>fd_snowflake_account_url</code>
2. <code>fd_snowflake_warehouse</code>
3. <code>fd_snowflake_username</code>
4. <code>fd_snowflake_role</code>
5. <code>fd_snowflake_password</code> (if you're using password based authentication)
6. <code>fd_snowflake_private_key</code> (if you're using key based authentication)

In addition, you can provide one of the following 2 variables to speed up scans and avoid cluttering your UI at Foundational:

1. <code>fd_snowflake_included_database_names</code> - a list of databases to include in our scan. Provide a list, individual items can support wildcards.
2. <code>fd_snowflake_excluded_database_names</code> - a list of databases to exclude from our scan. Provide a list, individual items can support wildcards.
3. <code>fd_snowflake_extract_history</code> whether to extract query history (default: True, recommended to keep that way)

1. Follow the instructions in <a href="https://docs.foundational.io/en/articles/8292929">How to set up Snowflake</a> to get Snowflake's connection parameters<i>.</i>
2. The details you've collected need to fit into:
   1. <code>fd_snowflake_account_url</code>
   2. <code>fd_snowflake_warehouse</code>
   3. <code>fd_snowflake_username</code>
   4. <code>fd_snowflake_role</code>
   5. <code>fd_snowflake_password</code> (if you're using password based authentication)
   6. <code>fd_snowflake_private_key</code> (if you're using key based authentication)
3. In addition, you can provide one of the following 2 variables to speed up scans and avoid cluttering your UI at Foundational:
   1. <code>fd_snowflake_included_database_names</code> - a list of databases to include in our scan. Provide a list, individual items can support wildcards.
   2. <code>fd_snowflake_excluded_database_names</code> - a list of databases to exclude from our scan. Provide a list, individual items can support wildcards.
   3. <code>fd_snowflake_extract_history</code> whether to extract query history (default: True, recommended to keep that way)

docker run --rm -d -e fd_api_key_id=xxxxx -e fd_api_key_secret=yyyyy -e fd_snowflake_account_url=https://sample-account.snowflakecomputing.com/ -e fd_snowflake_warehouse=COMPUTE_WH -e fd_snowflake_username=foundational_user -e fd_snowflake_role=foundational_role -e fd_snowflake_password="sample_password" -e fd_snowflake_excluded_database_names='["test_db_*","dev_db_*"]' public.ecr.aws/b3w3r6q2/on-prem-extractors:&lt;your-tag&gt; snowflake

Example Usage