Add files to tigergraph cloud using pyTigerGraph

Is there any way to add files on TigerGraph cloud using pyTG?
I have few csv files on Github and would like to load them in Vertex/Edge. I couldn’t find any gsql command or pyTG function which can add these files to TG cloud.
I tried loading github files in pandas dataframe and then using pyTG’s updateVertexDataFrame() but this doesn’t work when files/dataframes have some columns which contain blank/null values.

1 Like

@mt_nagarro Unfortunately, pyTG doesn’t have the features to upload files into TG cloud at this moment. It might be included in the future, but we would need to evaluate a process to do this without having full access to the underlying servers.

You mentioned exploring updateVertexDataFrame() and I’ve run into that same exact issue. I’m attaching my notebook that I’m retrieving files from a GitHub Repo and then using that function (after doing some data cleaning). I’m hoping it can help!

https://colab.research.google.com/gist/HerkTG/a73dbb641ac1f917423422782b85dea3/tigergraph_fincen_demo.ipynb#scrollTo=Q3DJFG6GKetZ

1 Like

@mt_nagarro I’ve attached an updated Colab that covers bulk uploads using loading jobs to the cloud via pyTigerGraph. I think this will solve your use case.

https://colab.research.google.com/drive/1fJpcv-q0NLfHj3X1k6Lbwddp8gVVcfES?usp=sharing

Supporting video: https://youtu.be/2BcC3C-qfX4?t=1945

1 Like

Thanks @Jon_Herke for your response and sharing the notebook. This surely helps!!

1 Like