Is there a way to import longer strings from BigQuery? It seems there’s an arbitrary cut off of 128 characters rn?

Yes, this is the limit set. However, Attribute labels and values text can hold up to 10,000 characters

Hello @Michael Ashmead, I don’t have a BigQuery at my hand, but if you experience issues when loading long strings into GD, try to increase the data type of the field in the LDM modeler. Go to dataset > More… > View details A reload of data will be required after you perform the change.

Thanks, will try this out 👍

Hi Michael, could you please send us the requestID from the log?

Hey, I just noticed your screenshot, and remembered that similar issue was already discussed here: https://community.gooddata.com/data-sources-59/how-do-i-use-google-bigquery-table-with-list-field-string-repeated-506 does it help?

I don’t think it’s a STRING REPEATED field type that I’m using? These are the fields I have for the table

Hi Michael, could you please try to run the following query above your source database so we can check if there is some problem with the “Message” table itself?

SELECT messageId AS messageId,senderId AS senderId,message AS message,conversationId AS conversationId FROM Message

Hi Michael, the error seems to be in querying and splitting of table Message, as my colleague Julius also mentioned. When i check our logs the select from this table is sql=“SELECT messageId AS messageId,senderId AS senderId,message AS message,conversationId AS conversationId FROM Message” but in the screenshot you have sent i can see column dateSent also. Could you please rescan your data source with “Connect” then rebuild your dataset in LDM by dragging and dropping the Message table from data source schema. Somehow the columns in your message table in BQ and the LDM does not seem to match. After rescanning and rebuilding your model then could you please try to rerun your schedule. Thanks.