2,932 questions
Best practices
0
votes
4
replies
66
views
Dynamic field search in Spanner DB
We're building a SaaS platform for which we need to design a data model which could accompany domain specific data. We don't know the structure of domain specific data. So these are the evaluated ...
- 323
0
votes
1
answer
98
views
postgres "<schema.function>" does not exist
I have a script in postgres to create test data and error Error: relation "schema" does not exist is being thrown. I have verified that the schema and function exists and that I can run the ...
- 937
Best practices
0
votes
0
replies
42
views
How would one draw an ERD for this question?
How would this relational schema be drawn as an ERD? My attempt is shown above, though it is incorrect. I do not understand why. Here is the relational schema:
CREATE TABLE student
(
name TEXT,
...
- 21
1
vote
1
answer
265
views
Retrieve schema name created with databricks asset bundles
I´ve created a schema in DAB with this code in my yml file.
resources:
schemas:
my_schema:
name: my_schema_name
catalog_name: my_catalog
The schema is created ...
- 33
0
votes
0
answers
110
views
Have I messed up my Swift Data Versioned Schema?
I have 5 Swift Data models:
SDPlanBrief, SDAirport, SDChart, SDIndividualRunwayAirport, SDLocationBrief
I went live with my first release of the app, with no migration plan or versioned schemas. ...
- 33
0
votes
1
answer
111
views
have SQLAlchemy or SQLModel define a database schema starting from an example of the object I would like to persist
I would like to save objects like this to a local database.
The object is a dictionary with various entries.
For instance, the first entries are like:
"id": "https://openalex.org/...
- 6,431
0
votes
1
answer
135
views
Unable to Add Columns to Existing Container in GridDB Python Client
I have an existing GridDB container created with the Python client:
from griddb_python import griddb
factory = griddb.StoreFactory.get_instance()
gridstore = factory.get_store(
host="127.0.0....
- 11
0
votes
1
answer
316
views
Why is schemaEvolution not working in databricks autoloader?
I'm reading csv files and processing them daily so I can append the data to my bronze layer in databricks using autolader. The code looks like this:
def run_autoloader(table_name, checkpoint_path, ...
- 906
0
votes
0
answers
92
views
Spark Scala - read and write to parquet file and retain the original schema
In the below scala code, I am reading a parquet file, amending value of a column and writing the new dataframe into a new parquet file:
var df = spark.read.parquet(sourcePath)
val newDf = df....
- 420
0
votes
0
answers
63
views
PDO Exception Unknown column when removing column from data table
I am currently working on removing deprecated columns from my database. After dropping a specific column, I encountered the following error:
SQLSTATE[42S22]: Column not found: 1054 Unknown column
'...
- 1
0
votes
1
answer
226
views
Unable to get SEARCH_PATH to take effect in queries
Our company has a policy where each app creates a dedicated database schema and two users per app schema - a runtime appname user and an admin appname-admin user (for running migrations). I was ...
- 23.5k
0
votes
1
answer
677
views
Visual Studio Schema Compare for a DB project is very slow, 45 to 60+ minutes to complete
I am using Visual Studio version 2022 to develop and maintain an application database.
The database has over 1900 tables,1600 stored procedures, 1600 views, 200 triggers, 120 functions...
It takes ...
0
votes
1
answer
92
views
How to model exclusive relation in relational database?
Let there be 3 tables: A, B, C.
A row in A may be associated to a row in B, or it may be associated to a row in C, but it must not be associated to both B and C.
In other words, the association is an ...
- 3,415
0
votes
1
answer
46
views
Prisma Schema Migrate
I got a problem when learning to create a schematic model of a prism, as below
model User {
id Int @id @default(autoincrement())
username String
email String @unique
password ...
0
votes
1
answer
105
views
Filtering out rows that don’t fit the schema in pyspark
I have a file named employee.csv with columns empid as integer and empname string. I am reading the files into a dataframe d1 by defining the schema and reading into another dataframe d2 as it is. The ...
- 33