Skip to main content

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 TINFO    ] 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. 

Hi @Chris Selph,

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

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


Terms & ConditionsCookie Settings