Getting Started with Your Avionté DataLink

Getting Started with Your Avionté DataLink

Welcome to Avionte’s DataLink! With this service, you have direct access to query your Insights data using SQL, either through the Snowflake platform or external tools. Here’s a step-by-step guide to get you started.

Step 1: Accessing Your Unique Server Information

After signing up, you should receive an email from Avionté with three key pieces of information to set up your data connection:

• Server Name/ URL: This is your unique server location where your data resides.
  • • If you are connecting to a third party BI tool, the Server name (Snowflake Server Name/URL from your onboarding email) format should be 'example.snowflakecomputing.com'  (excluding the https://)
• Customer ID: Your ID, which identifies your specific data environment.
• Password: A secure password for accessing your data.
  • • If you are connecting to a third party BI tool, you will need Warehouse name (formatted as PROD_WH_{Customer Specific Code}, the name of your Snowflake computing warehouse).

If you haven't received this information or need assistance, please reach out to our support team at [e-mail].

Step 2: Connecting to Your Data

You can connect to your data in two main ways:

1. Using the Snowflake Web Interface
   • Use the server name/ URL, customer ID, and password from Step 1 to log in.
   • This interface allows you to run SQL queries, explore tables, and view data directly.
2. Connecting Through External Tools
   • Avionte’s Enterprise Data is compatible with many external data tools like Tableau, Power BI, and Looker.
   • Most tools have a "Connect to Snowflake" option; input your server name, customer ID, and password when prompted.

Note: Ensure your tool’s connection settings are configured to accept Snowflake credentials.
 

Step 3: Running Your First SQL Query

Once connected, you can start querying your Insights data right away. To help you get started, here’s an overview of some core tables you’ll likely use:

• Fact Tables: These store quantitative data, essential for analysis.
  • FCTACTIVITY: Records applicant, job, and contact activities.
  • PLACEMENT_FACT: Details on placement-related metrics.
  • GROSSPROFIT_FACT: Contains gross profit figures tied to placements.
  • REVENUE_ACTIVITY_FACT: Tracks revenue and job activity data.
• Dimension Tables: These provide descriptive attributes for context.
  • DIMDATE: Contains dates, useful for time-based analyses.
  • DIMCOMPANY: Information about the company records.
  • DIMAPPLICANT: Holds applicant details linked to activities.
  • DIMOFFICE: Office-specific details, linking activities to offices.

 
Example Queries:

• Count of Records in FCTACTIVITY:

SELECT COUNT(*) FROM FCTACTIVITY;

• Filter Placements by Date in PLACEMENT_FACT:

SELECT * FROM PLACEMENT_FACT WHERE DATEKEY BETWEEN '20230101' AND '20231231';
 
These tables and their fields are detailed in the Data Dictionary in Snowflake, with information on column names, data types, and relationships. Use this as a reference to understand what each table holds and how it connects to others.

Step 4: Utilizing the Data Layout and Dictionary

Avionte’s Enterprise Data uses a structured data model called a star schema, with central Fact tables surrounded by Dimension tables that provide context and detail.
Here’s a quick overview of some core tables to help you get familiar:

• Fact Tables (e.g., FCTACTIVITY, PLACEMENT_FACT, GROSSPROFIT_FACT): These store quantitative data, such as activity counts and gross profit amounts, and link to Dimension tables through keys.
• Dimension Tables (e.g., DIMDATE, DIMAPPLICANT, DIMCOMPANY): These store descriptive details for facts, like dates, applicant names, or company details.

Each table and its columns are described in the Data Dictionary included in your Snowflake account. This dictionary lists each table, its columns, data types, and relationships, making it easy to identify which tables and fields are relevant to your queries.
 
With these steps, you’ll be ready to access and analyze your data on the Avionté DataLink. Happy querying!

Additional Resources

• SQL Reference Guide: Review basic SQL commands and examples.
• Customer Support: Our support team is here to help. Reach us at [e-mail]