Questions tagged [dbeaver]
DBeaver is a free and open-source (Apache License 2.0) universal database tool for developers and database administrators.
dbeaver
1,157
questions
-7
votes
0
answers
27
views
Full MongoDB in python guide [closed]
pip install pymongo
from pymongo import MongoClient
Connect to the MongoDB server
client = MongoClient('mongodb://localhost:27017/')
Select a database
db = client['mydatabase']
Select a collection
...
0
votes
0
answers
25
views
Connect to Datastax Astra DB in DBeaver
I need to connect to Astra using DBeaver. I'm following guide https://awesome-astra.github.io/docs/pages/data/explore/dbeaver/#astra-community-jdbc-drivers (exactly "Astra Community JDBC Drivers&...
- 905
0
votes
1
answer
62
views
Connecting PostgreSQL running on WSL from DBeaver on Windows (FATAL: password authentication failed for user "postgres")
I have my WSL2 running an Ubuntu 20.04 distro. I have installed my PostgreSQL (12.19) using apt-get.
I ran sudo passwd postgres to set password as root
I am able to access the DB from the WSL terminal ...
-2
votes
0
answers
27
views
What is the unity of time that dbeaver uses in his analytics? [closed]
I'm using dbeaver connected to a PostgreSQL database to create a SQL query. And I'm trying to get the analytics of that execution.
But I can't understand which unity of time it get as response.
My ...
0
votes
0
answers
30
views
Bulk Table export as DDL separated files in DBeaver
I am trying to export and entire database's schemas for tables, views, etc.
I must export the schemas as SQL individual files.
I've been doing it manually through the option generate SQL-> DDL but ...
0
votes
0
answers
30
views
How to configure an external formatter in DBeaver Snap Linux?
I'm trying to configure an external formatter for SQL queries in DBeaver, but I'm encountering a "permission denied" error. I'm not very experienced with the command line and just started ...
1
vote
0
answers
25
views
DBeaver - Set default Column Target Type for CSV Import data
I am trying to import a large number of CSV files as tables into DBeaver. With each CSV file, DBeaver seems to guess the column target type. Is there a way to stop this from happening? I want every ...
- 627
1
vote
0
answers
20
views
DBeaver disable ctrl+click = definition
My goal is disable ctrl+click leads to table definition.
I've searched and I've gone through most of the preferences. I even exported them to a csv file to try and search them for the thing to disable....
- 189
2
votes
2
answers
64
views
Postgres truncating timestamptz value to 3 places?
In my postgres database I have a table I'll call users with a timestamptz type column updated_time. When I execute a select statement on this field I will get something like this - '2024-07-01 12:30:...
- 385
0
votes
1
answer
50
views
View the definition of an existing table in PostgreSQL
I tried to get the query of an existing table in PostgreSQL database using DBeaver IDE. Query which was used to create the table and its relationships.
I tried mentioned below 4 queries but those are ...
- 16.6k
0
votes
1
answer
50
views
Connect to ADW with not ADMIN user in DBeaver
I have already created my ADW. I can connect to it with my ADMIN user (ussing the wallet) with Dbeaver. The connection configuration looks like this:
I have created a user for other person to connect ...
- 811
1
vote
2
answers
51
views
Getting SQL error in DBeaver connecting to Cassandra "NoNodeAvailableException: No node was available to execute the query"
There is a problem with working with Cassandra in DBeaver.
Cassandra 4.0.12
Cassandra JDBC Driver 4.9.0
After executing a simple Select query (SELECT * FROM tbl_file), an error occurs:
SQL Error: com....
0
votes
2
answers
84
views
Oracle - How to build a dynamic query for use in DBeaver
I come from a SQL Server background. How should I write the below to be able to run in DBeaver against an oracle database? I got bits of it from other questions here but cannot make it work in full.
...
- 49
0
votes
0
answers
54
views
DBeaver - Connecting to RDS instance through an ssh tunnel using AWS SSM
I have some RDS instances accessible through EC2 istances (each RDS has its jump EC2). Currently, I was using DBEaver Community edition to connect to the database configuring an ssh tunnel to the EC2.
...
- 41
0
votes
0
answers
43
views
How can I properly use Dynamic SQL queries using dynamic pivoting inside DBeaver's SQL Console?
Currently I have an SQL query where I am pivoting the values of one table and then joining that data with another table. The query works but the problem is that I had to hardcode the pivoting for each ...
