Snowflake-integrated applications
- name
- AppTemplate Snowflake Integration for HR
- business
- human resources
- tag
- DWH／Snowflake
- Connector used
- Snowflake Connector
Use Snowflake to:
- The process of aggregating data output from employee management, man-hour management, and project management in Snowflake and creating input CSV files to register in the HR system.
This application includes:
script
- Input CSV file creation script
- Initialization script
- This application requires HULFT Square Connector for Snowflake.
Script Details
Input CSV file creation script (snowflake_send_tables)
Reads a CSV file* and uploads it to a Snowflake table.
Based on the uploaded table data, the values are aggregated into an aggregation table and an input CSV file is created.
- Registration CSV file
[Employee Information.csv], [Project Implementation Information.csv], [Project Master.csv], [Customer Master.csv], [Process Information.csv], [Process Master.csv]
Initialization script (snowflake_preparation)
Clear the table data on Snowflake that you used and initialize the table.
How to install and use it