Athena View DDL

Answered
Avatar
Zahir Ally
Created

Hi, is it possible in Datagrip to view an AWS Athena's view's DDL?  I can see the list of views in the Database Explorer tree, but when I select one and select SQL Scripts → Generate DDL to Query Console, it outputs:

create view “default”."test_v" as
---  missing source code
; 

I'm using the latest Athena JDBC drivers (3.2.0) - https://docs.aws.amazon.com/athena/latest/ug/jdbc-v3-driver.html

Thanks!

Votes

0

Share

2 comments
Avatar
Miguel Monteiro
Created

It should be possible,  please create a new YouTrack request and provide the following:

1. IDE UI logs from Help | Collect Logs and Diagnostic Data

2. Right-click the data source > Diagnostics > Prepare Introspector Diagnostics 

0
Avatar
Zahir Ally
Created

Thanks, I've created this request here: https://youtrack.jetbrains.com/issue/DBE-21031/Support-for-Athena-View-DDL-Generation 

I can't attach any diagnostics data due to the sensitivity of my data sources.

0

Please sign in to leave a comment.