I have python code that read data from Athena and that works fine in AWS portal , but it's not working from my local computer because of security policies (using secret key is forbidden for us). This code uses awswrangler and boto3 to read the data. Now, i can connect to Athena from my computer via pyodbc and Simba Athena and that's fine. The problem is that i don't see how can i use this connection in awswrangler as i want to use the existing implementation there. Is there a way to pass pyodbc connection to awswrangler ? Or if it's possible to read the keys from pyodbc connection and pass them to awswrangler ?
How to connect to Amazon Athena using Simba ODBC and Python
148 Views Asked by Harry Birimirski At
0
There are 0 best solutions below
Related Questions in PYTHON
- How to store a date/time in sqlite (or something similar to a date)
- Instagrapi recently showing HTTPError and UnknownError
- How to Retrieve Data from an MySQL Database and Display it in a GUI?
- How to create a regular expression to partition a string that terminates in either ": 45" or ",", without the ": "
- Python Geopandas unable to convert latitude longitude to points
- Influence of Unused FFN on Model Accuracy in PyTorch
- Seeking Python Libraries for Removing Extraneous Characters and Spaces in Text
- Writes to child subprocess.Popen.stdin don't work from within process group?
- Conda has two different python binarys (python and python3) with the same version for a single environment. Why?
- Problem with add new attribute in table with BOTO3 on python
- Can't install packages in python conda environment
- Setting diagonal of a matrix to zero
- List of numbers converted to list of strings to iterate over it. But receiving TypeError messages
- Basic Python Question: Shortening If Statements
- Python and regex, can't understand why some words are left out of the match
Related Questions in AMAZON-WEB-SERVICES
- S3 integration testing
- How to get content of BLOCK types LAYOUT_TITLE, LAYOUT_SECTION_HEADER and LAYOUT_xx in Textract
- Error **net::ERR_CONNECTION_RESET** error while uploading files to AWS S3 using multipart upload and Pre-Signed URL
- Failed to connect to your instance after deploying mern app on aws ec2 instance when i try to access frontend
- AWS - Tab Schema Conversion don't show up after creating a Migration Project
- Unable to run Bash Script using AWS Custom Lambda Runtime
- Using Amazon managed Prometheus to get EC2 metrics data in Grafana
- AWS Dns record A not navigate to elb
- Connection timed out error with smtp.gmail.com
- AWS Cognito Multi-tenant Integration | Ok to use Client’s Idp?
- Elasticbeanstalk FastAPI application is intermittently not responding to https requests
- Call an External API from AWS Lambda
- Why my mail service api spring isnt working?
- export 'AWSIoTProvider' (imported as 'AWSIoTProvider') was not found in '@aws-amplify/pubsub'
- How to take first x seconds of Audio from a wav file read from AWS S3 as binary stream using Python?
Related Questions in BOTO3
- Problem with add new attribute in table with BOTO3 on python
- Python reading jpg file from s3 unidentified image error
- getting ids from nested bucket structure in s3
- AWS s3 boto3: Error when generating presigned URL The authorization mechanism you have provided is not supported
- bot3 ecs.execute_command: Task Identifier is invalid
- How to use Python's S3FS to delete a file that contains dashes and brackets in the filename?
- How can I set the log_stream_prefix to get the cloudwatch data from lambda
- AWS DynamoDB retrieve items in descending order
- Optimizing Async Batch Processing for AWS CloudWatch Log Downloads Using aioboto3 in Python
- Update session credentials on boto3 client rather than recreating the client
- Type error using combination of mypy and boto3 stubs
- Runtime.ImportModuleError unable to import module cannot import module name "DEPRECETED_SERVICE_NAMES" from botocore.docs
- Recursion Error when s3 client is initialized within Inference script for my SageMaker Endpoint
- Boto3 download all files in a subdirectory
- Why am I getting an error when deploying a model from my S3 bucket to Sagemaker?
Related Questions in AWS-DATA-WRANGLER
- why does aws sagemaker data wrangler not allow me to deploy model in canvas
- AWS Wrangler creating dictionary values on its own
- LakeFS, S3 Could not connect to the endpoint URL
- how to use athena VPC endpoint to query data from isolated network mode in sagemaker preprocesing job
- Partitioning Parquet AWS Wrangler with LakeFs
- Python Mocking AWS Wrangler / DB Connection
- How to upload periodically a .txt file to S3?
- Saving a dataframe as a parquet with geometry column
- Aws Data Wrangler - Local Pipeline Session Failure
- AWS wrangler writing wrong values in parquet
- Is there a way to setup retries / timeouts with `awswrangler.athena.read_sql_query`?
- Is it possible to omit header rows when exporting a SageMaker DataWrangler flow to s3 (via a Jupyer Notebook)?
- Which pandas module can be used read parquet file in parallel?
- How to connect to Amazon Athena using Simba ODBC and Python
- AWS Wrangler WaiterError: Waiter BucketExists failed: Max attempts exceeded. Previously accepted state: Matched expected HTTP status code: 404
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?