To download the taxonomy database from your Snowflake account (used in conjunction with RChilli), follow the steps below. This assumes that RChilli has provisioned your taxonomy data into a Snowflake environment:
Step-by-Step: Download Taxonomy Data from Snowflake
1. Log into Snowflake
-
Open the Snowflake web UI (
https://app.snowflake.com) or use the SnowSQL CLI. -
Use your credentials to log into the appropriate account region and warehouse that contains the taxonomy data.
-
If you're unsure of the credentials or warehouse name, please contact support@rchilli.com.
2. Switch to the Appropriate Database and Schema
USE DATABASE RCHILLI_TAXONOMY_DB;
USE SCHEMA PUBLIC;
3. Query the Taxonomy Tables
You might have access to tables such as skills, job_profiles, or taxonomy_metadata. Example:
SELECT * FROM skills;
4. Download the Data (CSV Format)
You can export the query result to a CSV using the following methods:
Option A: Snowflake Web UI
-
Run your query.
-
Click on the Download button (top-right of the result pane).
-
Choose CSV as the export format.
Option B: Use SnowSQL CLI
snowsql -a <account> -u <user> -d RCHILLI_TAXONOMY_DB -s PUBLIC -q "SELECT * FROM skills;" -o output_format=csv -o header=true > skills.csv
5. Secure Your Output
-
Ensure the file is stored securely if it includes proprietary or sensitive classification.
-
For regular exports, consider automating this process via scheduled jobs or scripts using SnowSQL or a BI tool (e.g., Tableau, Power BI).
Additional Notes
-
Refresh Frequency: The taxonomy database is refreshed monthly to include new skills, job titles, and multilingual enhancements.
-
API Alternative: If you prefer accessing taxonomy data dynamically instead of downloading, use the RChilli Taxonomy API:
-
Use it to retrieve skills, job profiles, aliases, and standardizations programmatically.
Need Help?
If you do not see the taxonomy tables or are unsure of access rights, email support@rchilli.com
Comments
0 comments
Please sign in to leave a comment.