Convert Redshift to Bigquery

Paste code here or Copy

xxxxxxxxxx
 
--Paste your source SQL here
create table sales(
   salesid integer not null,
   listid integer not null,
   sellerid integer not null,
   buyerid integer not null,
   eventid integer not null encode mostly16,
   dateid smallint not null,
   Boilerplate_content smallint not null encode mostly8,
   pricepaid decimal(8,2) encode delta32k,
   commission decimal(8,2) encode delta32k,
   saletime timestamp,
   primary key(salesid),
   foreign key(dateid) references date(dateid)
)
distkey(listid)
compound sortkey(listid,sellerid);
⇜
⇝
​x
 
​

Convert to Bigquery Error? Regenerate

Error?

Paste the error message to interactively regenerate

Regenerate

FAQs

User Privacy & Security

All user interactions are 100% private, secure and encrypted. Customer confidence is critical to everything we do at Roboquery

Does this tool convert Redshift SQL, Tables, Views to equivalent Bigquery Syntax ?

Yes, Roboquery helps you with Redshift to Bigquery code migration by taking the Redshift SQL and converting the code to Bigquery equivalent

Are there limits to how much code I can convert?

Yes. Daily usage quota aplies. Refer to Plans and Pricing

Does this require access to my database ?

No, The Roboquery code conversion utility is fully disconnected and a standalone application. You only share the database structures and we do not need any access to your data