Hello,
We wish to import data in a table from a csv. The copy command fails as super user permissions are not there. I have raised a ticket. But the issue is not resolved yet.
Are there any easy tools or any other options by which this can be executed? Copy data in a csv nia table.
regards
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Hello,
Indeed, uploading a file directly to a managed database is quite likely not going to work with the default permissions.
What I could suggest is to use a script to do the import. For example, you could use the following Python script to do the import:
Make sure to change the connection string and the table name.
Best,
Bobby