Qlik Truncate String Length

[isaiasdd92]

Hello!

I have a connection with Databricks, where I have a table with the geographic coordinates of Brazilian states.

However, this data is a string with many characters, and Qlik is only loading 255.

Is there any way around this?

I have already set the connection parameter to 16384 as the maximum string size, but it continues to get 255.

[marksouzacosta]

Hi @isaiasdd92,

Can you please provide the following:

1. Confirm if your data looks correct in Databricks
2. What is the field type and length in Databricks?
3. What is the Qlik Data Connection you are using to connect to Databricks?
4. Can you please Share your Load Script?

Regards,

Mark Costa

[Raju_6952]

 Hi @isaiasdd92 ,

instead of databricks connection can you crearte odbc connection and setup paramaters for chracters

length which you can extened as per your choice.

we also faced this challenges while loadaing the data from feedback reviews for the products which is more than 255 characters length.

Suggestion: We used simba spark odbc driver for our requirement.

Regards,

Siva Prasad

[isaiasdd92]

Hi @marksouzacosta 

1 - Yes, my data is correct in Databricks.

2 - Data type is string and not have a length in Databricks.

3 - I using a Databricks Connector in Qlik Sense SaaS, in Databricks I use a SQL Warehouse Serveless

4 - Sure, it's simples, just a script load a table from Databricks contains a Geolocation from states of Brazil.

UFs:
LOAD 
	KeyUF, 
	SiglaEstado, 
	IndicadorDivisaoAtendimentoCDs, 
	AreaEstado, 
	CoordenadasGeograficasEstado, 
	RegiaoUFTramontina, 
	CodigoPais, 
	DescricaoUnidadeFederacao, 
	RegiaoEstado;
SELECT 
	KeyUF,
	SiglaEstado,
	IndicadorDivisaoAtendimentoCDs,
	AreaEstado,
	CoordenadasGeograficasEstado,
	RegiaoUFTramontina,
	CodigoPais,
	DescricaoUnidadeFederacao,
	RegiaoEstado
FROM `adm_sit_gold_prd`.masterdata.`dim_uf`;

[isaiasdd92]

Hi @marksouzacosta 

1 - Yes, my data is correct in Databricks.

2 - Data type is string and not have a length in Databricks.

3 - I using a Databricks Connector in Qlik Sense SaaS, in Databricks I use a SQL Warehouse Serveless

4 - Sure, it's simples, just a script load a table from Databricks contains a Geolocation from states of Brazil.

UFs:
LOAD 
	KeyUF, 
	SiglaEstado, 
	IndicadorDivisaoAtendimentoCDs, 
	AreaEstado, 
	CoordenadasGeograficasEstado, 
	RegiaoUFTramontina, 
	CodigoPais, 
	DescricaoUnidadeFederacao, 
	RegiaoEstado;
SELECT 
	KeyUF,
	SiglaEstado,
	IndicadorDivisaoAtendimentoCDs,
	AreaEstado,
	CoordenadasGeograficasEstado,
	RegiaoUFTramontina,
	CodigoPais,
	DescricaoUnidadeFederacao,
	RegiaoEstado
FROM `adm_sit_gold_prd`.masterdata.`dim_uf`;

[isaiasdd92]

Hi @Raju_6952 

I am using a Qlik Sense SaaS, not have a option to ODBC Connection.

[isaiasdd92 · Accepted solution]

Hello!

I resolved the problem following the instructions in this link.

https://community.qlik.com/t5/App-Development/Does-column-length-in-SQL-SF-table-matter-when-reading...