📄️ 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
📄️ Improving Hex Magic
Best practices to ensure Magic gives you great results