Allowing Xplenty access to my Snowflake account

In order to allow Xplenty access to your Snowflake account, login to your Snowflake account using your favorite SQL client and execute the following commands to create a user with proper permissions for Xplenty:

USE ROLE accountadmin; -- use this role to be able to grant permissions
CREATE ROLE xplenty; -- create a role to assign to the Xplenty user
CREATE USER xplenty PASSWORD='<password>' DEFAULT_ROLE = xplenty; -- create a user with a password
GRANT ROLE xplenty TO USER xplenty; -- assign user to role

-- run the following statements for each database you'd like Xplenty to access:

GRANT USAGE ON DATABASE "<database_name>" TO ROLE xplenty; -- grant database access to Xplenty
GRANT CREATE SCHEMA ON DATABASE "<database_name>" TO ROLE xplenty; -- grant schema creation privilege to Xplenty
GRANT ALL ON SCHEMA "<schema_name>" TO ROLE xplenty; -- grant Xplenty privileges to do anything within the defined schema
GRANT ALL ON SCHEMA public TO ROLE xplenty;

-- run the following statements for each warehouse you'd like Xplenty to use:
GRANT ALL ON WAREHOUSE "<warehouse_name>" TO xplenty; -- allow Xplenty to use a warehouse

Once you've granted Xplenty access to your Snowflake, create a connection in Xplenty:

  • Click your avatar, then click Account settings.
  • Click Connections, then click new connection and click Snowflake.
  • Type a name for the connection.
  • Enter your account name (e.g. xplenty if you login to xplenty.snowflakecomputing.com)
  • Enter the user name and password you created for Xplenty to use.
  • Enter the default database to use.
  • Enter the default warehouse to use.
  • Set the region to your Snowflake's account's region.

Identifier names

Xplenty uses quoted identifiers which means that by default, all identifiers (table and column names for instance) are case sensitive - as opposed to non-quoted identifiers which are case insensitive (and are stored in upper case). You may want to change the behavior by changing the QUOTED_IDENTIFIERS_IGNORE_CASE setting for Xplenty's user or for your entire account. Note that tables and columns that were created with case sensitive names remain case sensitive, so it's important to make this change before you create any tables. If you want to switch a case sensitive identifier name to a case insensitive identifier name after it's been created use the ALTER ... RENAME clauses in Snowflake. Read more on Snowflake identifiers for more information.

Connectivity And Security

  1. Allowing Xplenty access to data on Amazon S3
  2. Allowing Xplenty access to my Redshift cluster
  3. Allowing Xplenty access to my data on Google AdWords
  4. Allowing Xplenty access to my data on Google Analytics
  5. Allowing Xplenty access to my Google BigQuery dataset
  6. Allow Xplenty access to my Google Cloud Spanner instance
  7. Allow Xplenty access to my data on Google Cloud Storage
  8. Allowing Xplenty access to my data on Hadoop Distributed File System (HDFS)
  9. Allowing Xplenty access to my server behind a firewall
  10. Allowing Xplenty direct access to relational databases on Amazon Web Services RDS
  11. Allowing Xplenty access to MongoDB
  12. Importing Heroku Connections
  13. Allowing Xplenty access to my data on Bing Ads
  14. Allowing Xplenty access to Azure SQL Databases
  15. Allowing Xplenty access to my data on Secure File Transfer Protocol (SFTP)
  16. Allowing Xplenty access to Facebook Ads Insights data (Beta)
  17. Allow Xplenty access your data on Salesforce
  18. Allowing Xplenty access to NetSuite
  19. Allowing Xplenty access to my data on Intercom
  20. Set up a reverse SSH tunnel from Windows
  21. Allowing Xplenty access to my data on Xero (Beta)
  22. Allow Xplenty access to my data on Azure Blob Storage
  23. Allowing Xplenty access to my Snowflake account
  24. Allowing Xplenty access to my data on YouTube
  25. Allowing Xplenty access to my data on Google Sheets
  26. Allowing Xplenty access to my data on Linkedin
  27. Allowing Xplenty access to my data on Instagram
  28. Allowing Xplenty access to my data on Shopify
  29. Allowing Xplenty access to my data on Pinterest
  30. Allowing Xplenty access to my Amazon Athena instance
  31. Allowing Xplenty access to my data on Xero

Feedback and Knowledge Base