Hugging Face's logo

Spaces:
Leon4gr45
/
twenty
Build error

App Files Community
1
twenty
File size: 1,563 Bytes
d9494a5
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
CREATE TABLE IF NOT EXISTS
    usageEvent_v2 (
        `timestamp` DateTime64 (3) NOT NULL,
        `workspaceId` String NOT NULL,
        `periodStart` DateTime64 (3),
        `userWorkspaceId` String DEFAULT '',
        `resourceType` LowCardinality (String) NOT NULL,
        `operationType` LowCardinality (String) NOT NULL,
        `quantity` Int64 NOT NULL DEFAULT 0,
        `unit` LowCardinality (String) NOT NULL DEFAULT 'CREDIT',
        `creditsUsedMicro` Int64 NOT NULL DEFAULT 0,
        `resourceId` String DEFAULT '',
        `resourceContext` String DEFAULT '',
        `metadata` JSON
    ) ENGINE = MergeTree
PARTITION BY
    toYYYYMM (timestamp)
ORDER BY
    (workspaceId, timestamp, userWorkspaceId)
PRIMARY KEY (workspaceId, timestamp)
TTL toDateTime(timestamp) + INTERVAL 3 YEAR DELETE;

INSERT INTO
    usageEvent_v2 (timestamp, workspaceId, userWorkspaceId, resourceType, operationType, quantity, unit, creditsUsedMicro, resourceId, resourceContext, metadata)
SELECT
    timestamp,
    workspaceId,
    userWorkspaceId,
    resourceType,
    operationType,
    quantity,
    unit,
    creditsUsedMicro,
    resourceId,
    resourceContext,
    metadata
FROM
    usageEvent;

RENAME TABLE usageEvent TO usageEvent_old;

RENAME TABLE usageEvent_v2 TO usageEvent;

DROP TABLE IF EXISTS usageEvent_old;

ALTER TABLE usageEvent ADD PROJECTION IF NOT EXISTS billing_by_workspace_period (
    SELECT
        workspaceId,
        periodStart,
        sum(creditsUsedMicro) AS totalCreditsUsedMicro
    GROUP BY
        workspaceId, periodStart
);