> Anyone who has worked for more than 5 minutes in an enterprise more than 30 miles outside San Fransisco know that the vast majority of information in the enterprise is cataloged and transacted via Excel spreadsheets. And if you're lucky, these spreadsheets are accessible to more than one person at a time via platforms like SharePoint.
This is large.
Or shall I say x-large?
It basically excels and will essentially solve all German Enterprise IT issues:
GitHubGitHub - gregwdata/ducklakexl: Use Excel as a metadata catalog for DuckLake 🤪Use Excel as a metadata catalog for DuckLake 🤪. Contribute to gregwdata/ducklakexl development by creating an account on GitHub.
New 
️
![SQL statement:
```sql
CREATE OR REPLACE VIEW observations AS (
FROM read_csv('awk ''{print $1,$4,$11}'' fast.log | sed -e ''s/:[0-9]+$//'' |', delim=' ', header=false)
SELECT
strptime(column0, '%d/%m/%Y-%H:%M:%S.%f') AS ts,
column1 AS id,
regexp_replace(column2, ':[0-9]+$', '') AS ip
WHERE regexp_matches(ip, '\d+\.\d+\.\d+\.\d+')
);
```](https://files.mastodon.social/media_attachments/files/114/445/026/029/935/629/original/8ebb936e0ed468d6.png "SQL statement:
```sql
CREATE OR REPLACE VIEW observations AS (
FROM read_csv('awk ''{print $1,$4,$11}'' fast.log | sed -e ''s/:[0-9]+$//'' |', delim=' ', header=false)
SELECT
strptime(column0, '%d/%m/%Y-%H:%M:%S.%f') AS ts,
column1 AS id,
regexp_replace(column2, ':[0-9]+$', '') AS ip
WHERE regexp_matches(ip, '\d+\.\d+\.\d+\.\d+')
);
```")
Hacker News 
