![]() ![]() If you’d like to ask a public question or let us know about a bug, we recommend asking on SQLpipe’s Github page. If it is unsuccessful, you will get an error message.Ĭomplete API documentation for the transfer command is available on the SQLpipe transfer documentation page. If the command is successful, the program will print a completion message. The “–query” flag denotes the query to be run on the source database.The “–overwrite” flag indicates that SQLpipe should drop the table specified by the “–target-table” and “–target-schema” flags, then create a new table in the target database with the query result’s column names and types.The “–source-ds-type” and “–target-ds-type” flags denote the database type and must be one of SQLpipe’s supported systems.We would run the following command: sqlpipe transfer \ -source-ds-type "mysql" \ -source-hostname "your-mysql-hostname" \ -source-port 3306 \ -source-db-name "your-mysql-db-name" \ -source-username "your-mysql-username" \ -source-password "your-mysql-password" \ -target-ds-type "redshift" \ -target-hostname "your-redshift-hostname" \ -target-port 5439 \ -target-db-name "your-redshift-db-name" \ -target-username "your-redshift-username" \ -target-password "your-redshift-password" \ -target-schema "your-redshift-schema-name" \ -target-table "name-of-table-to-insert-into" \ -overwrite \ -query "select * from users" Let’s say we want to transfer a table called “users”, from MySQL to Redshift. Running a transfer is accomplished with the “sqlpipe transfer” command and passing some information via flags. The next step is gathering the following information for both MySQL and Redshift: If installation is successful, the version command will print something like this: Git hash: d3b390c Human version: 1.0.0 Step 2 – Gather connection information ![]() Run the version command to check installation success:.Grant execution permission to run with:.Download the pre-built binary from our downloads page with your browser or command-line tool like curl.If you would like step by step installation instructions, check out our installing SQLpipe page. You can search for your database type or click Databases to find it. You can get it from the SQLpipe downloads page. Go to Data
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |