Does the SFTP/FTP datasource support compressed files?
Yes, files with an .zip or .gz extension can be ingested. Make sure your file name includes the compressed file extension in order for the datasource to pick up the correct files ie
Is there a file size limit for manual uploads?
100 MB zipped.
Are there restrictions for custom column names?
Yes, column names must:
Be no longer than 127 characters long
Begin with an underscore or letter
Only contain numbers, underscores, and letters
Will adding new columns to an existing datasource drop my table?
if they are metrics, it will not drop
if they are dimensions, it will drop
Can I rearrange the columns of an existing datasource?
Yes, you can rearrange the columns, but in redshift/bigquery, tables will just be at the end of the columns.
What date formats are acceptable within Alli?
Acceptable formats are MM/DD/YYYY and YYYY-MM-DD.
If a time appears after the date (ex.
1/1/2023 12:00:00 AM), the time will be stripped.
Cannot connect to redshift
[Amazon][Amazon Redshift] (10) Error occured while trying to connect: [SQLState 08S01] could not connect to server: Connection timed out (0x00000274C/10060) Is the server running on host ”redshiftdata.pmg.com” (22.214.171.124) and accepting TCP/IP connections on port 5439?
Are you on the office wifi? Reach out in #alli-data
If you’re not on the office wifi, connect to the VPN and try again.
Can we pull data from custom grouping from Google Analytics?
One can only pull Default grouping from Google Analytics API. Custom Groupings aren’t supported by Google Ads API.
Google Datasources 400 Error