Skip to main content
Solved

Perceived Anomalies With SQL DB Extractor


Chris Selph
Seasoned
Forum|alt.badge.img

Hello, I have a SQL table that has 2000 rows total. The SQL DB Extractor 3.0 configured to extract all rows (Select *) and places them in a Raw table.

The extractor log shows 2000 rows extracted.

2024-08-02 00:00:05.558 UTC [INFO    ] ThreadPoolExecutor-2_0 - No more rows for Caster_LabData_Narrow. 2000 rows extracted in 0.047 seconds
2024-08-02 00:00:05.558 UTC [INFO    ] ThreadPoolExecutor-2_0 - Reporting new success run: No more rows for Caster_LabData_Narrow. 2000 rows extracted in 0.047 seconds

 

The Raw table UI shows it has only 1000 rows of data, not the 2000 I am expecting. How can I confirm the exact number of rows in the Raw table? 

I tried to select all rows from that raw table with a transformation and the preview only showed 1000 rows BUT I can’t tell whether that is a transform preview UI limitation or not.

As a test, I tried to select all rows from a different raw table with 1993 rows with a transform and place the results in a 3rd raw table. The resulting 3rd table only shows 1495 rows which is perplexing and further exacerbates the problem. 

Best answer by Dilini Fernando

Hi @Chris Selph,

I am glad that the issue has been resolved after adjusting the configuration file. I will be closing this thread. If you have any further questions or need additional assistance, please don't hesitate to create a new post.

View original
Did this topic help you find an answer to your question?

2 replies

Dilini Fernando
Seasoned Practitioner
Forum|alt.badge.img+2
  • Seasoned Practitioner
  • 671 replies
  • August 5, 2024

Hi @Chris Selph,

I will create a support ticket so that our team can follow up and assist you. 


Dilini Fernando
Seasoned Practitioner
Forum|alt.badge.img+2
  • Seasoned Practitioner
  • 671 replies
  • Answer
  • August 30, 2024

Hi @Chris Selph,

I am glad that the issue has been resolved after adjusting the configuration file. I will be closing this thread. If you have any further questions or need additional assistance, please don't hesitate to create a new post.


Reply


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings