Skip to main content
Question

Does anybody have pycelonis sample to get DB data?

  • Sep 26, 2023 5:22 AM UTC
  • 3 replies
  • 139 views

Hi all,

 

I'd like to know how to fetch data from data in data pool via pycelonis. Usually I'm using read_excel or read_csv module in my local python but don't know how to read database column from pycelonis. Does anybody know how to do that or sample code in git-hub?

 

Thanks 

3 replies

muthappan.alaga
Level 8
Forum|alt.badge.img

  • Sep 27, 2023 10:36 AM UTC

Caveat: if you retrieve data from the data Ingestion (i.e. from Data pools tables, using SQL) you will retrieve only 100 lines.

 

If you want all the data you need to add the table to a temporary data model, upload it, then query it using PQL


  • Sep 27, 2023 6:17 PM UTC

Use this sample code link