Suggest an Idea

[ppatelquilk]

Hello:

Just found out that when replicating from Postgresql with partitions to Snowflake missing basic functionality.

on target Snowflake data gets copied from source Postgres partitions to target snowflake partitions, on target data can't be queried from parent table. To get latest data have to query latest partition not the parent table. it works fine when source is Oracle.

[Shelley_Brennan]

Thank you for your post.  We have a couple of questions about your request.

What version of PostgreSQL are you running? 

Have you have opened a related Support case about this issue?  If so, could you share the case number so we can review?

And finally, is your request to overcome this limitation which exists when using Parallel Load feature with PostgreSQL source:

• Table segmentation by partitions or sub-partitions is not supported with the PostgreSQL source endpoint.

[Shelley_Brennan]

We'll need more information to reconsider this request - thank you.

[ppatelquilk]

Hello:

we are using aurora postgres 11.9

Yes we opened support case and recommended to submit idea.

[Shelley_Brennan]

Could you share the support case number?  Also, could you answer the question above to clarify the exact limitation you are trying to overcome?  Thank you!

[ppatelquilk]

Hi Shelley,

Here is a case no.

02145134 - TABLE IS NOT GETTING UPDATED

The problem we try to overcome with this is it should work without any work around.

Like Oracle when query parent table should return rows from all partitioned tables.

In postgres it doesn't.

Thanks.