Data Sources

MySQL

• Incremental loads
• The importance of having a primary key

File Upload

• The importance of having a primary key
• Different delimited files
• Supported file types
• What is the size limit for file uploads?

General

• Identifying my parent to child tables relationship
• Joining the main table with its subtables
• Can I ingest 2 data sources into the same table?
• Why am I getting 1600 columns limit error?
• The order of ingestion from files
• The Incremental Key option for database data sources

See all 19 articles

Salesforce (SFDC)

• Selecting the needed objects
• Selecting additional resources
• Incremental loads
• Custom fields explanation
• How do we fix the error: "Session expired or invalid"?

Google Adwords

• Adding additional reports after a successful collection
• Historical loads
• The return value of cost or money fields

Facebook Pages

• Metrics Selection
• Date ranges

Postgres

• Incremental loads
• The importance of having a primary key

Google Sheets

• Frequently changed sheets
• Refreshing the list of files
• Formulas in sheets
• Rows and headers don't align error

Facebook Ads

• Date ranges
• How to change the breakdown

S3

• Collecting specific folders and files
• Sending data from the same S3 bucket to different tables
• Recollecting files
• Identifying the source file for each record
• The importance of having a primary key
• Supported file types

See all 10 articles

GoogleAnalytics (GA)

• Date ranges
• Dimensions and primary keys
• API limits