To ensure your team has seamless access to scan data, Flowcode offers two primary delivery methods: SFTP and Snowflake Data Sharing. Whether you prefer a CSV file delivery for your own servers or a direct database-to-database connection, we have you covered.
Option 1: SFTP Access (Secure File Transfer)
This method is ideal if you want scan-event or form submission data delivered daily in CSV format to a secure environment hosted by Flowcode.
Delivery Frequency & Formats
You can choose how your data is packaged each day:
Daily: A new file containing only the previous day’s scan events.
Cumulative: A new file containing all historical scan events to date.
How to Set Up SFTP
To gain access, you must use SSH Key Authentication.
Generate a Key Pair: You will need to generate a private and public SSH key.
Share the Public Key: Send us your Public Key (typically ending in .pub).
Connect: Once we white-list your key, use your Private Key to connect to the Flowcode SFTP server and retrieve your files.
Technical Guide: Generating Your SSH Key
If you chose the SFTP method, follow these steps to generate your credentials:
Open your terminal (or Git Bash on Windows).
Run the generation command: ssh-keygen -t ed25519 -C "[email protected]"
Save the files: The process will create two files:
Private Key: Keep this secret! You will use it to log in.
Public Key (.pub): This is the file you share with the Flowcode team.
For a more detailed walkthrough, you can follow the GitHub Guide to Generating SSH Keys.
Option 2: Snowflake Data Share
If your organization uses Snowflake, this is the most efficient delivery method. Instead of managing files, we provide a secure "Data Share" that gives you direct, real-time access to our tables.
Benefits
Easy Access: Query the Flowcode 2 Events table directly within your own Snowflake instance.
Always Cumulative: No need to stitch daily files together; the data is always up-to-date and historical.
Zero Storage Overhead: You aren't "copying" the data; you are viewing it via a secure share.
How to Set Up Snowflake
To enable this, please provide your Snowflake Account Identifier. Once we initiate the share on our end, you can create a database from the share in your Snowflake console.
To better understand the specific fields and metrics within your scan data, please reach out to your Customer Success Manager. They will share a detailed Data Dictionary to help your team map out your reporting and analytics.