Copying app with partition to SQL

[Bellave_Jayaram]

Hi all,

I am looking for feedback from users who have successfully copied an app with data partitions from Gsheet to SQL.

Did you encounter any issues? How easy was the migration? Do the separate tabs for each partition convert seamlessly to separate SQL tables or views?

Tagging the usual bleeding edgers -
@Grant_Stead @MultiTech_Visions @Reza @Stefan_Quartemont

[Grant_Stead]

I have not experienced this as of yet.

[Stefan_QREW]

I haven’t tried a Copy App function from Gsheets -> SQL data source with partitions before.

My guess is that it would copy seamlessly, so long as your table names are distinct in your Gsheet partitions.

If it doesn’t sync seamlessly, I’d make a copy of the app (not a copy of the data) and remove the partitions, then Copy App into SQL. Then do a manual schema copy of that SQL table for as many partitions as you need, do the data export/upload dance, and then add them as new partitions to the SQL based app.