G

Thursday, November 26th, 2020 2:28 PM

How to change the driver for existing schema

Hi Team,
We are ingesting data from Amazon Redshift to Collibra through on-prem jobserver. Earlier we have used an amazon provided driver and ingested metadata. Now we would like to change this driver to Collibra provided driver. We already have lots of relations with the existing schema ingested using amazon provided driver.
The collibra provided driver is working fine separatley. When I try to refresh the existing schema using the newly added collibra provided driver it throws me a error “java.lang.ClassNotFoundException: com.amazon.redshift.jdbc42.Driver”. Can you please let me know if there is way to solve this without breaking the existing relations.

Thanks & Regards,
Guna

4 Messages

 • 

50 Points

4 years ago

Hi

if you want to start using a new driver to refresh an already ingested schema going forward, you will need to create a new driverprofile: https://productresources.collibra.com/docs/cloud-user/2020.11/#Catalog/RegisterDataSource/JDBC/ta_manage-jdbc-driver-collibra-provided-driver.htm

When this is done, you can go to the schema where you want the new driver to be used, click refresh and select the new driver profile from the driver dropdown which you can see below
image

Hope this helps

Peter

4 years ago

Hello Peter, Yes I tried this, it does work, however I have a concern related to performance.
In my case, earlier we used Amazon provided redshift driver to load metadata, it used to take around 15 to 20mins maximum, but when I changed the driver to the same schema to collibra provided driver it is taking more than 3hrs.
is this expected? Even the second time it is taking more than 3 hrs.

4 Messages

 • 

50 Points

Hi

this is not how it should be, please create a support ticket for this with your configuration details so they can assist you with this.

1.2K Messages

@gunasekharreddy.kaluva.non.se.com If you need assistance navigating to our Support Portal, you can visit this link to submit directly: https://support.collibra.com/hc/en-us/requests/new. Hope that helps!

1.2K Messages

4 years ago

Tagging @peter.princen to ensure he sees your response. Thank you for your sharing!

4 years ago

Hello Bridget,

I have raised a support ticket, thank you so much for your response.

Regards,
Guna

16 Messages

4 years ago

Can you please share the outcomes / findings upon this question with the community please?

Thank you,

Kind regards
Axel

4 years ago

Sure, I can do that, as of now there is no update

Loading...