I am connected to Redshift from SQL Developer 19.2.1.
I have a requirement to export multiple query output into a single excel sheet, one query output should be in one Tab. Please advise on how to achieve this.
Thanks
Export mutliple query output into one excel sheet using Redshift and SQL Developer
csvexceloracle-sql-developerredshift
Related Solutions
When you do Export data from the database (using the wizard - Import\Export)
select -- write a query to specify data transfer.
If you are creating package from scratch using BIDS, then in the execute sql task editor, in the sql statement
then in the data flow task in the source query specify T-SQL query as below :
if you remove first two lines (var ... and exec), you can run this in sql_developer and get your results in a grid.
Now, if you must have variable declaration, you could replace the : to a & in "job.contract_year in (2013,:v_yr)" so it will prompt you to enter a value at run time.
If you must convert this to a procedure, then you need to go the ref_cursor route.
Related Question
- Oracle SQL Developer 4: how to tell under which user I connected
- Sql-server – Create a monthly job to export from SQL Server 2014 to Excel
- Sql-server – Updating SQL table from Excel sheet (using powershell)
- Sql-server – Pulling SQL Server data into Excel
- How to correct SQL Server Import and Export Wizard error that says the data conversion length must be between 0 and 4000
Best Answer
If you want to export the data from Redshift to excel you can use some software like Talend Open Integration or export directly to CSV with the UNLOAD functionality that Redshift has.
https://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html