How to load csv data in Cloud SQL(Postgress) table automatically from compute engine

[srikanta parida]

Hi ,

Can somebody help me ? i wanna load csv into Cloud SQL(Postgress)  automatically from compute engine .i am able to connect cloud sql (postgress) from compute engine .But i want load csv  generated from XML in compute engine  into Cloud SQL(Postgress) .

Could anybody suggest me on this..

BR//

Srikanta

 

[George (Cloud Platform Support)]

Hello Srikanta, 

You can't load the CSV file directly from your Compute Engine instance, you'll have to upload the CSV file to a bucket in Cloud Storage first. Relevant steps are listed in the "Importing the CSV file" sub-chapter of the "Importing data into Cloud SQL" documentation page. To automate this procedure, you may consider writing an appropriate script. 

This discussion group is oriented more towards general opinions, trends, and issues of general nature touching App Engine and Cloud SQL. For scripting and data import automation, you may be better served in dedicated forums such as stackoverflow, where experienced programmers are within reach and ready to help.