Flat File

flat files such as txt, csv, and standard excel (xls, xlsx) formats are not going to disappear we still love them and so do you on the occasion use dlh io to upload and synchronization of files into your cloud data warehouse destination of choice dlh io provides this connector as a direct way to work with data files as a source to be loaded into several destinations of your choice pre requisities access to your files in order to be uploaded and processed key details maximum file size 20mb setup instructions no credentials should be necessary to access the files and they should not be password protected in any way using the form please complete the following basic steps enter a name or alias for this connection, in the name/alias field, that is unique from other connectors enter in the ' target schema prefix field, a name that will be unique in your target cloud warehouse destination database where you wish to land the data click the save button which will save the connection and return you to select this connection from the list to begin the upload process from the form click the upload file(s) button select the file(s) you wish to upload note there is a limit on the number of files per connector, so select on the file(s) required and then adjust later if you need to source a large number of flat files, please use one of the other cloud based file folder connectors once the files have uploaded they should appear towards the bottom of the connector you cannot edit this files but they can be overwritten by upload the file with the same name again how to instructions control each column data type sql transformations docid 5zjgrvbhtywqw8 olioh0 allow logic to be executed against a target connection based on a scheduled frequency or triggered event of new data on tables updated via datalakehouse io (dlh io) this especially helps when you want to control the data type set in your target connection since all columns are set as varchar(16777216) issue handling if any issues occur with the authorization simply return to the sources page in datalakehouse io, edit the source details and click the save & test or authorize your account or re authorize account button to confirm connectivity if any issues persist please contact our support team via the datalakehouse io support portal https //datalakehouse zendesk com