CSV as Data Source?

[yosuke-coupa]

As described in the following, Data Access Gateway can only be associated with a single Tenant and Space.

Data Gateway - Direct Access: Cannot share a singl... - Qlik Community - 2069393

We are considering re-architecting our data flow to remove the Data Access Gateway from the equation.  It has been suggested that exporting and importing our data as CSV with a custom backend worker service may be an option.  

CSV is a valid data source as described in the documentation.  

Loading data from files | Qlik Cloud Help

However, there is not much information that I could find on what to expect with CSVs as data sources. 

• The expected format?
  • null?
  • Date/time?
  • quotes on fields?
• Performance implications?  
• How does Qlik determine the data type?

Could someone point us to understand better how CSVs as data sources work?  

[Pablo007 · Accepted solution]

Dear @yosuke-coupa , 

You can give format to the CSV fields on the Qlik script when you read the data,  ie;

date( your datefield) as date

I do not know the motivation to use CSV,  but maybe you can use also excel,  or an ORAcle database, or SQL.

And I do not understand at 100% your problem with gateway,  so please accept my excuses if below sentence is not accurated for your porblem

Maybe you can try to use gateway with one user,  create QVD files to feed qlik and let the other users read this qvd

Thanks & good luck!