Adding Data

• Contact your Snowflake administrator to create an account
• Get your account identifier from the Snowflake console URL
• Set up password or private key authentication
• Request access to a warehouse and appropriate role

• USAGE on schema – Access schema objects
• SELECT on tables – Query table data for analysis
• SHOW privilege – View table metadata and structure

Connection Method: HTTPS over port 443

IP Addresses: 100.20.92.101, 44.225.181.72, 44.227.217.144

Connects to <account>.snowflakecomputing.com – may require firewall allowlisting

• Create an IAM user in AWS Console
• Attach appropriate Athena and Glue policies
• Generate access keys for the IAM user
• Create an S3 bucket for query results

• athena:StartQueryExecution – Run SQL queries
• athena:GetQueryExecution – Monitor query status
• athena:GetQueryResults – Retrieve query results
• s3:ListBucket – Browse data locations
• s3:PutObject – Write query results to S3
• s3:GetObject – Read query results from S3
• glue:GetDatabases – List available databases
• glue:GetDatabase – Read database metadata
• glue:GetTables – List tables in databases
• glue:GetTable – Read table schema and metadata

Connection Method: HTTPS over port 443

Connects to AWS API endpoints – no specific firewall rules needed

• Contact your AWS administrator for cluster endpoint
• Request a database user account with appropriate permissions
• Ensure your network can reach the Redshift cluster
• Test connection using standard PostgreSQL tools

• CONNECT privilege on database – Establish connections
• Valid username and password – Authentication credentials
• USAGE on schema – Access schema objects
• SELECT on information_schema.schemata – List available schemas
• SELECT on pg_tables – List tables in schemas
• SELECT on information_schema.tables – Access table metadata
• SELECT privilege on tables – Query table data for analysis
• SELECT on pg_class and pg_namespace – Access table descriptions

Connection Method: PostgreSQL protocol over port 5439

Port: 5439

IP Addresses: 100.20.92.101, 44.225.181.72, 44.227.217.144

May require VPN access or IP allowlisting depending on cluster configuration

• Sign in to Google Cloud Console
• Create a service account with BigQuery permissions
• Download the service account JSON key
• Copy and paste the JSON content above

• BigQuery Job User
• BigQuery Metadata Viewer
• BigQuery Data Viewer

Connection Method: HTTPS over port 443

IP Addresses: 100.20.92.101, 44.225.181.72, 44.227.217.144