AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Metabase athena2/26/2023 ![]() : AthenaJDBC An error has been thrown from the AWS Athena client. Note that the Resource is * so this will give Delete/Update permissions to any table.Īfter upgrading to new version(v1.1.0) we are not able to sync the athena to metabase.Ġ8-03 15:09:16 INFO sync.util :: STARTING: Sync metadata for athena Database 2 'Athena'Ġ8-03 15:09:16 DEBUG middleware.log :: POST /api/database/2/sync_schema 200 1.5 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 3/50 (6 idle, 0 queued) (112 total active threads) Queries in flight: 0 (0 queued)Ġ8-03 15:09:16 INFO sync.util :: STARTING: step 'sync-timezone' for athena Database 2 'Athena'Ġ8-03 15:09:16 INFO sync.util :: FINISHED: step 'sync-timezone' for athena Database 2 'Athena' (94.0 µs)Ġ8-03 15:09:16 INFO sync.util :: STARTING: step 'sync-tables' for athena Database 2 'Athena'Ġ8-03 15:09:24 ERROR sync.util :: Error running sync step If your customer-base needs access to create tables for whatever reason, they will need additional AWS Glue permissions. Build the project and copy the jar from the export stage.The entire jar can now be built from the included Dockerfile. ![]() Other options can be found in the "Driver Configuration Options" section of the Athena JDBC Driver Installation and Configuration Result set streaming is a performance optimization that streams results from Athena rather than using pagination logic, however it requries outbound access to TCP port 444 and not all organizations allow that. For example, to disable result set streaming and enable TRACE-level debugging, use UseResultsetStreaming=0 LogLevel=6. You can provide additional options if necessary. ![]() If you need an example IAM policy for providing read-only access to your customer-base, check out the Example IAM Policy below. The initial sync can take some time depending on how many databases and tables you have.If you do not provide an access key, the default credentials chain will be used.The provided bucket must be in the same region you specify.You'll need to provide the AWS region, an access key and secret key, and an S3 bucket and prefix where query results will be written to. Once you've started up Metabase, go to add a database and select "Amazon Athena". 04-15 06:14:08 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :athena.Ġ4-15 06:14:08 INFO driver.impl :: Registered driver :athena (parents: ) □ ![]()
0 Comments
Read More
Leave a Reply. |