Run query against Amazon Redshift and an on-premises source at the same time

0
votes

We are working with an Amazon Redshift cluster and for sure our on-premise source data. Sometimes we need to run queries combining Redshift and on-premises data. To explore my data in both sources I work with DataGrip.

I know that SQL has functions like OpenQuery that can query different DB sources in the same transaction. I'm wondering whether DataGrip could do that or how else could I try to reach out in a query to Redshift and on-premises?

1
amazon-web-servicesamazon-redshiftjetbrains-idedatagrip
Did you try to plug it as an external schema in Redshift? - moscas
How could I do that? @moscas - Andres Urrego Angel
Please, see: docs.aws.amazon.com/redshift/latest/dg/… - moscas

1 Answers

1
votes

I think you have a couple of options

  1. Use a bi tool that enables data federation, there are a few of these. for example you may be able to use amazon quicksight. (this would not be sql though)
  2. If possible, mirror your onsite data to s3 and then use redshift spectrum to join to that data