Get your data
Learn simple methods to get your data into Hex by uploading files and setting up data connections
Parameterize SQL queries
Make your SQL queries dynamically respond to user input
Connect to Google Sheets
Connect Hex to Google Sheets so you can access, read, & write to a spreadsheet
Connect to S3
Set up a connection between Amazon S3 and Hex
Connect to GCS
Set up a connection between Google Cloud Storage and Hex
Writeback to your database
Use Writeback cells to write dataframes to your database
Read and write to your database with Python
Use Python to write tables from Hex to your SQL database
Hex's built-in hextoolkit package
Learn how to use the hextoolkit Python package and run queries with it
Merging data sources
Combine and work with multiple data sources across CSVs, dataframes, and databases