Data Lakes for Reporting

ClearCompany’s Data Lake for Reporting supports you with sophisticated analytics needs and capabilities for organizations who want more customization and deeper insights than our pre-built reports provide. It gives in-house data analysts and reporting power users direct access to their snowflake data captured in ClearCompany so they can build and populate complex reports with their own BI tools and real-time data.

In this article:
What are Data Lakes for Reporting?
Data Lakes Terminology
Data Lakes: Data Available
Data Lakes: Who is a good fit?
Data Lakes: Frequently Asked Questions
Additional Resources

What are Data Lakes For Reporting?

Data Lakes for Reporting gives you powerful insights by looking at detailed data about your hiring processes, candidates, and hires. This data was difficult to access and required ClearCompany assistance. Now, you can access your data directly, look for insights, and combine it with data in other systems to provide a powerful look at hiring impacts. You will use your own BI tool or the embedded Snowflake functionality to build reports and drive business insights.

This is a technical feature. We advise that you have some technical acumen or a structure of business analysts/IT support.

Data Lakes: Who is a good fit?

We recommend Data Lakes for Reporting if you have one or more of the following:

1. An internal BI/Analytics Teams
2. Large data sets
3. Those who want to build internal apps/widgets/dashboards on top of their data
4. Must provide a BI tool to connect to OR be willing to use Snowsight
5. Understanding of SQL and data models

Data Lakes: Data Available

Data List

1. Recruiting Data
2. Candidate Data
3. Employee Data
4. Office Data
5. Offer Letter Data
6. Onboarding Data
7. Performance Data

Data Lakes: Frequently Asked Questions

How can I confirm that our BI (Business Intelligence) tool connects to Snowflake?

Here is a list of provided BI tools and technologies that are known to provide native connectivity to Snowflake.

Can I use Snowflake Data Access without a BI Tool?

Yes, you can utilize SnowSight, which distills Snowflake’s powerful SQL support into an easy-to-use experience without needing a 3rd party BI tool. Please check out this article: Get Started with Snowsight!

Will ClearCompany write the queries I need in our BI Tool/Snowsight?

No. With the purchase of the Data Lake Product, ClearCompany will provide the Data Dictionary and a provisioned account. It is the responsibility of your organization to write your own queries needed for the reports, widgets, and/or dashboards you are looking to create.

I need a report on data that is not currently available in Snowflake. Can this be added?

Possibly. Not all data and data tables are in Snowflake currently. If you are looking to report on data that is not currently available, please reach out to your ClearCompany Representative. We will need to understand what you are looking for, and then we will conduct a feasibility study to see if the data can be added. If it can be we will provide a timeline on when the data will be added.

How often is the Data Dictionary updated?

The Data Dictionary is a Google Document, meaning each time you access the Google Doc, you will see the most up-to-date version. The Dictionary will be updated any time new data is added to Snowflake and if any changes have been made to the table structures in Snowflake. You will be alerted when new data is added to Snowflake and the documentation is updated.

Are there any caps on the amount of data or queries I can run?

At this point in time, no.

View the attached document for a look at this service.

Additional Resources

Interested in a report using our stock reports as a foundation, check out Custom Reports.