This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I am trying to access the MS-access file from S3 location. But when i am trying to access i am getting the below error message. i suspect there is something wrong only on the JDBC URL from the Generic Database Account connection. Below is my URL.
JDB...
I have a requirement to extract data from MS-Access Data and load into Redshift through Snaplogic. Can i know if we have any connectors to connect with MS-Access from Snaplogic ?
I am trying to load the data from fixed width flat file. In Fixed-Width Parser snap i can able to remove header through skip option. But can i know , is there any possible way to remove the footer ?
i am getting the input value from the flat file. i am reading all the column values and have to load in the target table only if it is a number. Can i know is there any built-in function to validate or handle this.
i think you are right. I did a sample test and it is moving through each file. I will develop further and keep you posted.
Thanks for your quick response. It helps.
Thanks for your response. It helps.
i separated using split function, but when i was trying to assign them using array for each variable like $myarray.find(x => x[1]), $myarray.find(x => x[2]), $myarray.find(x => x[3]), $myarray.find(x => x[4]) ...
