NOTE: After you import a Google Sheet into
, renaming the source Google Sheet or a tab in it can break your datasets and flows. Details are below.
D s product
- Creation of a dataset with parameters from Google Sheets is not supported.
- Connected sheets or embedded external datasources in your Google Sheets are not supported.
- A Google Sheet can contain up to 5,000,000 cells. Each cell can contain up to 50,000 characters.
supports a maximum of 25,000 characters in a cell.
D s product
- Filepath and source row number information is not available from original Sheets. These references return values from the CSV files that have been converted on the backend. For more information, see Source Metadata References.
Source Sheets files with cells bracketed by single double quotes may not be properly ingested if any terminating quotes are missing.
Tip: You can check the data quality bars for mismatched values or, for strings, the data histogram bars for anomalous values to see if the above issue is present. If so, deselect Detect Structure on import. Then, use a Split rows transformation applied to the affected column to break up the column as needed.