duneanalytics / docs Goto Github PK

Documentation for Dune

License: MIT License

HTML 31.60% JavaScript 2.23% CSS 66.17%

docs's Introduction

Archived Documentation

Please note that this documentation has been archived and is no longer being updated. For the latest documentation, examples, and API reference, visit the new Dune Analytics documentation repository at https://github.com/duneanalytics/dune-api-docs.

We encourage all users to refer to the new docs for the most current information and resources. Thank you for your understanding.

docs's People

Contributors

Stargazers

Watchers

Forkers

0x4c756b65 wakamex markusbkoch sam-bcap va3093 jethalo megoytambayan nobumei dschlabach frankloud jagadeeshmarali artivilla rodrigoieh rnhttr peiwangdb hungchihkuo isabella232 lukkiddd scottincrypto missing-9 skale-jace defifunk keivinonline zheli hildobby 0xkoios msilb7 codingtalent brianmillsjr ioandraghici jamesbachini chuxinh masroormumtaz jacubcub sevik-the-degen cryptofreedman 0xroll maui-r omahs reservoirprotocol unevenlabs 0xm3tatr0n adshao rayzhudev ramos181422 fjx2000 alexthelion123 rachi26 cgq0123 hosuke springzh mumu-ya debu976116 gm365 lviswang tapstoone gcunmercy pro0xbi allenzhao ponzicryptoape loa-ding andrewhong5297 minaminao gmh5225 0xkylin alextothesun kkkkkguo jrfrantz shellandbull austindgk232 kalikho jadendurnford marcovugts kalbroni7 jk-apybara nuszhiqinghu abuchtela chenxsan nhra168 0xrobin 0x1100010010 generalodogwu12 dao-collab harrodyuan plr0001 nazihkalo jbradach mushang12 dosseyson amadu-66 sithkhamsing cupojoseph 0xbhagi agrawal-utkarsh koroem dawidowak goliranyan r1372 yuanbuyuan1 davideaimar

docs's Issues

[Bug?] Example doesn't work

docs/docs/app/upload-data.md

Lines 20 to 24 in d833e0e

    
           ```sql 
        
           SELECT * FROM information_schema.columns  
        
           WHERE table_schema = 'dune_upload'  
        
           AND table_name = 'energy_data'; 
        
           ```

I tried running this query to get an idea of dune_uploaded tables, but it looks like we can't query the information schema anymore...

@Raen111 is attempting to deploy a commit to the Duneanalytics Team on [Vercel](https://vercel.com).

          @Raen111 is attempting to deploy a commit to the **Duneanalytics** Team on [Vercel](https://vercel.com).

A member of the Team first needs to authorize it.

Originally posted by @vercel[bot] in #386 (comment)

How to check who star my dashboard

How could i know my stargazers?

Just like github

QuickStart is not DuneSQL Compatible

Discord AwesomeQA sent me to this link for an interval question, but this references old interval formatting which fails in DuneSQL:
https://github.com/duneanalytics/docs/blob/master/zh/docs/getting-started/query-quick-start/example.md#blob-path

pemberitahuan

Dear sir ,my name joko purwanto male birth 30 maret 1970 from indonesia city Blora propenci jawa tengah post kode 58254 add my account BNI 46 BNINIDJASMG 0954380327- USD joko purwanto number B8967514 Republik of Indonesia on behalf of joko purwanto legal

select
            h.day
            ,(select evt_tx_hash from all_events where evt_block_time <=  h.day limit 1) as hash
from 
            unnest(SEQUENCE(timestamp '2022-05-20 00:00', CURRENT_DATE, interval '1' day) )  AS h(day)

Passing parameters to embedded chart?

I have the following query which supports 2 parameters:
https://duneanalytics.com/queries/85255?limit=100&days=30

However, the embedded version doesn't seem to support GET query parameters?
https://duneanalytics.com/embeds/85255/170174/e76617da-af8d-42a7-ad4e-6e9f927e706c?limit_=1&days=1
(limit_ & days ignored)

Is this possible? I could not find a documentation for this. if it is not possible, could you please add this feature? :)

Discord link is not working request for a api key!

can you give me e a new link of discord. need a test api key. thanks.

	```sql
	SELECT * FROM information_schema.columns
	WHERE table_schema = 'dune_upload'
	AND table_name = 'energy_data';
	```